Onboarding project | SQLNinja
đź“„

Onboarding project | SQLNinja

Hi there, we'll take this one step at a time!

​

​If you struggle with a blank canvas, use this boilerplate to start. Remember, this is a flexible resource—tweak it as needed. Some sections might not apply to your product and you might come up with great ideas not listed here, don't let be restricted.

This is not the only format, we would love to see you scope out a great format for your product!

​

Go wild and dive deep—we love well-researched documents that cover all bases with depth and understanding.

​


Product Brief (Continuing from Acquisition project):

SQLNinja is a gamified, AI-assisted SQL learning platform. It understands the user's current competency level and career goals by asking questions in the beginning and creates a tailored path for learners to teach them exactly what they need to learn in order to go to the next level.

Let's create an ideal customer profile:

We also created ICP during the same acquisition project. We will be adding some more nuances to the product features that are used most on the product, what features these ICPs value most, how frequently they use these features, and how much money they are willing to spend on each use case.

​

Below is the original ICP. At the bottom, there are more nuances related to product usage:

Criteria

Final year college student - looking to get a job in the data analytics field

Analytics professional with 1-2 years of experience

Non-technical professional moving to the data analytics field with 1-2 years of experience

Name

Rashi

Sandeep

Rizwan

Age

19-24

20-26

23-30

Demographics

​

  • Gender: All
  • Income Level: gets pocket money from parents
  • Education Level: Final year student (Bachelors)
  • Occupation: Student
  • Marital Status: Single
  • Geographic Location: Tier 1, Tier 2 & Tier 3 cities
  • Life Stage: Student

​

  • Gender: All
  • Income Level: average 25-50k INR
  • Education Level: Bachelor's degree
  • Occupation: Employed
  • Marital Status: Single
  • Geographic Location: Tier 1 cities
  • Life Stage: Young professionals

​

  • Gender: All
  • Income Level: average 15-35k INR
  • Education Level: Bachelor's degree
  • Occupation: Employed
  • Marital Status: Single
  • Geographic Location: Tier 1, Tier 2 cities
  • Life Stage: Young professionals

​

​

Need

Get a job

Upskill

Transition to data jobs

Pain Point

Low pocket money,
Learn multiple skills,
Overwhelmed with an abundance of SQL platforms,
Getting placed

Go deep in core data skills, Unawareness of analytics career roadmap,
Differentiating themselves compared to peers,
Overwhelmed with an abundance of SQL platforms,
Getting learning saturation

Low pay in the existing jobs,
Unaware of the entry point in analytics,
Learn multiple skills,
Overwhelmed with an abundance of SQL platforms

Solution

Learn a core data skill to become employable

Learn a core data skill in-depth

Learn a core data skill to transition to data jobs

Behavior

​

  • Blockers and Influencers to purchase: Friends, parents
  • Buying Behavior: Frugal
  • Benefits Sought: convenience & functional
  • Engagement Level: Highly active on social media - Instagram, Twitter & Tiktok
  • Subscribe to educational content
  • Technology Adoption: Early adopters
  • Interests and Hobbies: Partygoers, video gaming
  • Pain Points and Challenges: Looking for efficient platforms to learn SQL
  • Psychographic Factors: Get social recognition after getting a job

​

  • Blockers and Influencers to purchase: peers, managers
  • Buying Behavior: Spends on e-commerce products, buys household stuff
  • Benefits Sought: Become a master at one core employable skill
  • Engagement Level: Highly active on social media - Instagram, Twitter & Tiktok
  • Subscribe to educational content & build a network on Linked
  • Interests and Hobbies: Partygoers, video gaming, traveling
  • Pain Points and Challenges: Looking for a promotion
  • Psychographic Factors: Get social recognition after getting a job

​

  • Blockers and Influencers to purchase: peers, managers
  • Buying Behavior: Spends on e-commerce products, buys household stuff
  • Benefits Sought: Learn one core data skill to switch careers to the data industry
  • Engagement Level: Highly active on social media - Instagram, Twitter & Tiktok
  • Subscribe to educational content & build a network on Linked
  • Interests and Hobbies: Partygoers, video gaming, traveling
  • Pain Points and Challenges: Looking to get more salary
  • Psychographic Factors: Get social recognition after earning more

​

Perceived Value of Brand

NA as the product is in early PMF

NA as the product is in early PMF

NA as the product is in early PMF

Marketing Pitch

Learn the most important data skills - SQL with an AI tutor

Learn advanced SQL and shine at your work with SQL AI tutor

Transition to a data career by learning the most important skills - SQL with an AI tutor

Goals

Get a decent job in the salary range of 30-100k

Get a promotion

Transition to a data job for a better career prospectus

Frequency of use case

Daily during job placements

2-3 times a week (mostly during the weekend)

2-3 times a week (mostly during the weekend)

Average Spend on the Product

1000 INR

3000 INR

3000 INR

More product usage nuances are below:

Most of the features and their benefits have been covered in detail in the acquisition projects so skipping them here to keep it more direct and crisp. Please refer to the acquisition projects if more elaboration on product and market is required.

Criteria

Final year college student - looking to get a job in the data analytics field

Analytics professional with 1-2 years of experience

Non-technical professional moving to the data analytics field with 1-2 years of experience

Name

Rashi

Sandeep

Rizwan

5 Most used features

  1. Daily Challenges
  2. Gamification
  3. Tailored Learning Paths​
  4. AI-guided learning
  5. Progress tracking​
  1. Role-Specific Challenges
  2. Tailored Learning Paths
  3. AI-guided learning
  4. Dynamic Practice Question Bank​
  5. Progress tracking
  1. Daily Challenges
  2. Gamification
  3. Tailored Learning Paths​
  4. AI-guided learning
  5. Progress tracking​

2 Most values feature

  1. Daily Challenges
  2. Gamification

​

  1. Role-Specific Challenges
  2. Tailored Learning Paths

​

  1. Daily Challenges
  2. AI-guided learning


Frequency of use

Daily

2-3 times a week

2-3 times a week

Money to spend for use case

While there is not one solution that fits them all. Any product that can help the user build a core skill to get a job can demand up to 5k INR given the need for the product. The use case of the product doesn't fall under wants but a need.

This ICP is more desired-driven. They have a job and want to progress in their career by going deep into one core technical skill. They also know about multiple other competitors and free resources that can help them achieve their goals. They do have the money but would be less willing to pay more than 5k as this is a desirable goal.

This ICP is as clueless as ICP1 - freshers. They need someone to handhold them. They also have the money to pay to upgrade their skills. They can also spend as much as 10k INR if someone is solving their problems in the best way.

​ICP prioritization table:

We do have the below ICP prioritization framework.

Criteria

Freshers

Entry-level data professional

Entry-level non-data professional

Adoption Curve

High

High

Medium

Appetite to Pay

Medium

High

High

Frequency of Use Case

High

Medium

Medium

Distribution Potential

High

High

Low

TAM (Worldwide)

15 Million

2.3 Million

25 Million

Define user goals and JTBD

(Understand user goals and their JTBD on the platform. When looking at user goals, look at 4 themes, user goals will always be within one of the four)​

Objectively what is the user achieving out of your product/service? (use this table to put down your goals and draw JTBD thereon)

In user goals and JTBD, We try to answer three major questions here:

  1. Who is signing up? - Refer to the previous ICP section for the same.
  2. What are they trying to do? - We have three core ICPs for this project - Freshers, Entry-level data professionals & Entry-level non-data professionals. We have identified that each of these ICPs has a certain pain point that they want to solve by achieving a certain goal. For instance, A fresher wants to get a job and the rest of 2 ICPs want to get ahead in their career and earn more money.
  3. Why are the users signing in on your product? - Let's look at this from the eye of each ICP. What are the different goals that they can accomplish using SQLNinja to learn SQL:

JTBD/ICP

Freshers

Entry-level data professional

Entry-level non-data professional

Personal

Freshers are eager to acquire new skills that enhance their employability. Learning SQL can empower them with the foundational data skills necessary for various roles in tech and business, helping them grow personally and professionally.

For entry-level data professionals, enhancing their SQL skills is crucial for building a robust career in data analytics or data science. They aim to deepen their knowledge and gain hands-on experience with SQL to excel in their roles and advance in their careers.

Entry-level non-data professionals may see learning SQL as a way to diversify their skill set and enhance their value in the workplace. Gaining a basic understanding of SQL can open up opportunities to collaborate with data teams and contribute to data-driven projects.

Financial

By mastering SQL, freshers can significantly improve their chances of landing their first job in data-related fields, leading to financial independence through their initial salary.

Proficiency in SQL positions them favorably for promotions and salary increases. They seek competitive compensation that reflects their growing expertise and the high demand for skilled data professionals.

​

While they may not be in data-specific roles, having SQL skills can make them more competitive in the job market, potentially leading to better job offers and salary packages as they transition into more data-centric positions.

Social

They seek validation and recognition from peers and potential employers. Freshers want to showcase their newly acquired skills on platforms like LinkedIn, seeking to build connections and demonstrate their commitment to personal growth.

They aim to build a professional reputation within the data community. Networking with other data professionals and sharing their insights or projects can help them gain respect and visibility, leading to career advancement opportunities.

They want to be seen as versatile team members who can contribute to data-driven decisions. Gaining SQL skills allows them to engage in discussions about data and prove their value in a data-centric workplace.

Functional

Freshers need to learn SQL effectively and efficiently to gain foundational data skills. Their job is to acquire knowledge through engaging tutorials, practice exercises, and assessments that prepare them for entry-level roles.

These professionals need to enhance their SQL skills to perform data analysis and reporting tasks efficiently. Their job involves mastering advanced SQL queries, optimizing database performance, and working with real-world datasets to deliver actionable insights.

Non-data professionals need to understand SQL basics to do their analysis independently and not rely on the data team for simple queries. Their job is to learn how to query databases and interpret results to support their work in cross-functional projects.

Based on different goals for each ICP, below is the JTBD matrix:

For freshers and Entry-level non-data professionals, the primary goal is to get more money (Financial goal), whereas for Entry-level data professionals, the primary goal is to enhance their skills and deepen their knowledge of SQL.

​

Goal Priority

Freshers

Entry-level data professional

Entry-level non-data professional

Primary

Financial

Personal

Financial

Secondary

Personal

Financial

Functional

Tertiary

Social

Social

Social

Least priority

Functional

Functional

Personal

​

Do user research to validate or invalidate these goals

(You want to talk to users and understand why they're signing up. What's the end goal for them and for what job are they "hiring" your product for)


While SQLNinja is still in the pre-PMF phase. We have done some research on the Reddit community to validate some of our hypotheses on primary goals for ICP 1 and ICP 3. Below are some of the examples -

Why did you learn SQL?

on Reddit? Link

here

.

(Relevant for freshers from employability POV)


​

Screenshot 2024-08-24 at 4.03.38 PM.png

Can you get a job with just SQL? (importance of SQL for freshers and

other professionals to get employable)


​

Screenshot 2024-08-24 at 3.49.50 PM.png

Is it still worth to learn SQL?

Link

How SQL increases hiring potential and help one progress with their career. (importance of learning SQL for fresher to get into data analytics)

Screenshot 2024-08-24 at 3.58.07 PM.png

​

Is SQL worth a career pivot?

Link

(This is another validation of why a non-data professional will learn SQL. Such questions have huge upvotes and there are many answers like this.)

Screenshot 2024-08-24 at 4.06.18 PM.png

​

Reddit questions - I want to practice SQL on a Daily basis. Suggest me a book/resource -

Link


Screenshot 2024-08-24 at 4.57.55 PM.png

Onboarding Teardown

Step 1 → Start right from your homepage or App listing page
Step 2 → Take screenshots of every single page and interaction throughout the onboarding right till activation.
Step 3 → Start by putting yourself in your customer's shoes. Have empathy for their pain points and then analyze the page/screen.

Link to Onboarding Teardown Slides.

PDF Document - Onboarding Teardown - SQLNinja.pdf

Upon going through the onboarding journey, we have identified that some of the core features of ICP1 and ICP3 were discovered in the journey early such as Daily Challenges and Gamification. However, there were major challenges with personalized learning and how the platform will cater to various learners by providing role-specific challenges. The biggest Aha moment for the user was to see their progress in real time after solving the first daily challenge.

Defining your Activation Metric

Step 1 → Hypothesize at least 5 activation metrics that could be there for your product. (More the better)

1 -

Hypothesis: Solving the SQL query within 1 day of signup is a core activation metric
Reasoning: Solving a query requires the users to go through the question and write an actual SQL query. It requires users to put an effort to successfully solve a query. Upon solving the users receive points and start building a streak, that provides more motivation to the user to solve the problem on the next day.

​

2-

Hypothesis: Maintaining a streak for 3 days is a core activation metric
Reasoning: Solving queries for 3 days straight suggests that the users are finding the platform well-suitable for their goal and have the motivation to show up every day. Duolingo's streak feature is one of the most important feature for retention and same can work for a similar gamified platform on SQLNinja.

Step 2 → After this, mention in detail all the metrics you'd be tracking and why are you tracking them.


3-

Hypothesis: Progressing and achieving the L2 badge is the core activation metric
Reasoning: There might be some users who might not be able to solve SQL on the daily basis - specially the users who are working professionals. For them, the core activation metric could be attaining the next badge.

Step 2 → After this, mention in detail all the metrics you'd be tracking and why are you tracking them.

Metrics that needed to be tracked:

  1. % of users who solved their first problem within 1 day post-sign-up: Activation metric for 1st hypothesis
  2. % of users maintaining a streak for 3 days by sign-up date: Activation metric for 2nd hypothesis
  3. % of users attaining L2 badge: Activation metric for 3rd hypothesis
  4. The ratio of homepage to sign-up: To identify opportunities for conversion rate optimization
  5. The ratio of sign-up to the first query solved: To identify opportunities for conversion rate optimization
  6. D3, D7, D14, D30, M2, M3 retention: SQL learning requires practice & higher retention across at least 3 months

​

​



Brand focused courses

Great brands aren't built on clicks. They're built on trust. Craft narratives that resonate, campaigns that stand out, and brands that last.

View all courses

All courses

Master every lever of growth — from acquisition to retention, data to events. Pick a course, go deep, and apply it to your business right away.

View all courses

Explore foundations by GrowthX

Built by Leaders From Amazon, CRED, Zepto, Hindustan Unilever, Flipkart, paytm & more

View All Foundations

Crack a new job or a promotion with the ELEVATE

Designed for mid-senior & leadership roles across growth, product, marketing, strategy & business

View All Resources

Learning Resources

Browse 500+ case studies, articles & resources the learning resources that you won't find on the internet.

Patience—you’re about to be impressed.